# -*- coding: utf-8 -*-
from db.mysql import MysqlClient
from common.helper import Helper
from itertools import product

name = "无忧行百年高额交通意外险"
mysql = MysqlClient()
plan = {
    "planA": {
        "year":  "23-50"  ,
        "days":  "7d"  ,
        "people_count":  "1"  ,
        "airplane_death":  "2000000"  ,
        "accident_medical":  "5000"  ,
        "price":  "1.98"  ,

    },
    "planB": {
        "year":  "23-50"  ,
        "days":  "7d"  ,
        "people_count":  "1"  ,
        "airplane_death":  "1000000"  ,
        "accident_medical":  "5000"  ,
        "price":  "1.68"  ,
    },
    "planC": {
        "year":  "23-50"  ,
        "days":  "7d"  ,
        "people_count":  "1"  ,
        "ship_death":  "1000000"  ,
        "accident_medical":  "5000"  ,
        "price":  "1.68"  ,

    },
    "planD": {
        "year":  "23-50"  ,
        "days":  "7d"  ,
        "people_count":  "1"  ,
        "common_death":  "500000"  ,
        "accident_medical":  "5000"  ,
        "price":  "1.98"  ,
    },
    "planE":{
        "year":  "23-50"  ,
        "days":  "7d"  ,
        "people_count":  "1"  ,
        "private_death":  "500000"  ,
        "accident_medical":  "5000"  ,
        "price":  "2.98"  ,

    }
}
for k in plan:
    data = plan[k]
    data["name"] = name
    data["company"] = "百年人寿"
    Helper.mergeTable(name,mysql,data)
